# coding: utf-8

from marshmallow import Schema, fields
from model.model_base import Base
from sqlalchemy import Column, String


class EquipmentVenderList(Base):
    # 生产厂家对照表
    __tablename__ = 'EquipmentVenderList'
    venderid = Column(String(4), primary_key=True, comment='厂商id')
    vendername = Column(String(50), nullable=False, comment='厂商名称')
    classifyid = Column(String(2), nullable=False, comment='设备厂家分类')


class EquipmentVenderListSchema(Schema):
    venderid = fields.String()
    vendername = fields.String()
    classifyid = fields.String()


equipmentVenderListSchema = EquipmentVenderListSchema()

